<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <meta http-equiv="Content-Style-Type" content="text/css" />
  <meta name="generator" content="pandoc" />
  <meta name="version" content="S5 1.1" />
  <meta name="author" content="" />
  <title>Introduction to Tableau</title>
  <style type="text/css">
      code{white-space: pre-wrap;}
      span.smallcaps{font-variant: small-caps;}
      span.underline{text-decoration: underline;}
      div.column{display: inline-block; vertical-align: top; width: 50%;}
  </style>
  <!-- configuration parameters -->
  <meta name="defaultView" content="slideshow" />
  <meta name="controlVis" content="hidden" />
  <!-- style sheet links -->
  <link rel="stylesheet" href="www/slides.css" type="text/css" media="projection" id="slideProj" />
  <link rel="stylesheet" href="www/outline.css" type="text/css" media="screen" id="outlineStyle" />
  <link rel="stylesheet" href="www/print.css" type="text/css" media="print" id="slidePrint" />
  <link rel="stylesheet" href="www/opera.css" type="text/css" media="projection" id="operaFix" />
  <!-- S5 JS -->
  <script src="www/slides.js" type="text/javascript"></script>
</head>
<body>
<div class="layout">
<div id="controls"></div>
<div id="currentSlide"></div>
<div id="header"></div>
<div id="footer">
  <h1></h1>
  <h2>Introduction to Tableau</h2>
</div>
</div>
<div class="presentation">
<div class="title-slide slide">
  <h1 class="title">Introduction to Tableau</h1>
</div>
<div id="what-is-tableau" class="slide section level1">
<h1>What is Tableau?</h1>
<p>Tableau is a data visualization tool that can be used to explore and visualize data through a simple and user-friendly interface.</p>
<ul>
<li>First exploration of data</li>
<li>Building dashboards</li>
<li>Monitoring of key indicators</li>
</ul>
</div>
<div id="where-does-this-fit-in-our-datawork-plan" class="slide section level1">
<h1>Where does this fit in our datawork plan?</h1>
<ul>
<li>We learned how to clean, process and construct data on Stata</li>
<li>We also learned how to analyse the data through preparing graphs</li>
<li>Tableau can be useful if you want to use your final data to create dashboards for monitoring your key indicators</li>
<li>Tableau has some basic ways for manipulating and cleaning data, however, these are not reproducible and as flexible enough as Stata</li>
</ul>
</div>
<div id="dashboard-for-public-procurement-in-croatia" class="slide section level1">
<h1>Dashboard for public procurement in Croatia</h1>
<p><img src="img/croatia-dashboard.png" style="width:70.0%" /></p>
</div>
<div id="other-visualization-examples-from-tableau-website" class="slide section level1">
<h1>Other visualization examples from Tableau Website</h1>
<p><img src="img/tableau-example.png" style="width:60.0%" /></p>
</div>
<div id="how-to-start" class="slide section level1">
<h1>How to start?</h1>
<ul>
<li>We should start with pre-cleaned data that already has all our constructed indicators</li>
<li>You can load several pre-cleaned datasets at different levels of observation to Tableau at the same time</li>
<li>Identify all the indicators and variables you are most interested to visualize on Tableau</li>
<li>Keep only the indicators and variables that you want to visualize (use <code>keep</code> for this)</li>
<li>Keep the ID variables if you want to load data from different levels of observation at the same time</li>
<li>Then export the dataset in excel to import into Stata (use <code>export excel</code>)</li>
</ul>
</div>
<div id="what-will-we-learn-in-this-session" class="slide section level1">
<h1>What will we learn in this session</h1>
<ul>
<li>We will use a sample of a pre-cleaned contract level dataset for this session</li>
<li>We will learn how a visualization can be created using data imported into the session (Workbook)</li>
<li>We will learn how several visualizations can be combined into a dashboard page</li>
<li>We will learn how filters can be applied to a dashboard page</li>
</ul>
<p>The exercises will be conducted on Tableau and recorded with a video for later reference</p>
</div>
<div id="we-will-first-connect-tableau-to-the-data" class="slide section level1">
<h1>We will first Connect Tableau to the Data</h1>
<p><img src="img/import-to-tableau.png" style="width:75.0%" /></p>
</div>
<div id="we-will-first-connect-tableau-to-the-data-1" class="slide section level1">
<h1>We will first Connect Tableau to the Data</h1>
<ul>
<li>Tableau Desktop usually opens to a new worksheet where you can first connect it to your data exported before</li>
<li>You can have many options for the data source of your tableau dashboard. It can be an excel file, csv, txt etc.</li>
<li>You can also connect the dashboard to a server directly if using Microsoft SQL, MySQL, Amazon Redshift, etc</li>
<li>Once you connect the data you will see it pop up in your data source tab</li>
</ul>
<p><span style="color:blue">Let’s try this now</span></p>
</div>
<div id="visualizations-on-a-workbook" class="slide section level1">
<h1>Visualizations on a Workbook</h1>
<ul>
<li>The left hand side of your screen will have three main lists, Data Source, Dimensions, Measures.</li>
<li>Dimensions are any dicrete or text variable in your dataset</li>
<li>Measures are any numericals in your dataset</li>
<li>You can rename the dimensions and measures in your dataset by right-clicking it and selecting ‘rename’</li>
<li>You can use the dimensions and measures in your dataset to create visualization</li>
</ul>
<p><span style="color:blue">Let’s create a map of Croatia with total contracting value per county</span></p>
</div>
<div id="lessons-on-visualizing-maps" class="slide section level1">
<h1>Lessons on visualizing maps</h1>
<ul>
<li>Make sure that the geographical role for your location variable is well defined (right-click on location variable)</li>
<li>The country (in sub-country locations) may be incorrect in default settings, so you can change that when you create the map</li>
<li>The map can be customized to include aggregated numerical data in many multiple settings. You can explore the marks widget for different visualization settings</li>
</ul>
<p><span style="color:blue">Let’s create a line graph for contracting volume over years and a bar graph for contracting volume over evaluation method</span></p>
</div>
<div id="lessons-on-visualizations" class="slide section level1">
<h1>Lessons on visualizations</h1>
<ul>
<li>You can filter out the null values from a chart as needed in the chart</li>
<li>You can customize the appearance of the chart by changing the color, text and font on the chart</li>
<li>You can use the ‘Show Me’ tab to explore the different viable options for visualization as needed</li>
<li>You can add filters to your workbooks so you can change the scope of your chart as you wish</li>
</ul>
<p><span style="color:blue">Let’s add filters to all our workbooks for CPV Division name, Firm County, Postupak Nadmetanje Name</span></p>
</div>
<div id="lessons-on-filters" class="slide section level1">
<h1>Lessons on filters</h1>
<ul>
<li>You can drag the dimensions you want to add filters for to the ‘Filters’ widget on an existing workbook</li>
<li>You can decide whether you want to apply all categories of the filter to the chart or only a selection</li>
<li>You can right-click on the filter to apply the filter to all woksheets or a selection of worksheets (this will have implications on your final dashboard)</li>
<li>You can select whether you want to show the filter beside the chart</li>
<li>You can customize the appearance of the filter as you would like to see it in the dashboard</li>
</ul>
<p><span style="color:blue">Let’s combine our worksheets to a dashboard</span></p>
</div>
<div id="lessons-on-dashboard" class="slide section level1">
<h1>Lessons on Dashboard</h1>
<ul>
<li>You can simply drag the graphs from the worksheets to an empty dashboard sheet</li>
<li>You can move around the graphs as you please for your appearance customization</li>
<li>Using Layout options for horizontal or vertical boxes can help setting your visualization structure</li>
<li>You can select ‘Distribute Contents Evenly’ under the drop-down options for the boxes to ensure even space use</li>
<li>Check if your filters apply to all the charts you intend it to work on and re-adjust if not</li>
</ul>
<p><span style="color:blue">Keep playing around with Tableau Desktop options to customize and structure your visualizations!</span></p>
</div>
</div>
</body>
</html>
